﻿ALTER TABLE employer DROP CONSTRAINT fk_kind_of_activity_id2
GO

CREATE TABLE kind_of_activity_for_employer (
	kind_of_activity_id INT CONSTRAINT fk_kind_of_activity_id3 FOREIGN KEY (kind_of_activity_id)
						REFERENCES kind_of_activity (kind_of_activity_id) NOT NULL,
	employer_id INT CONSTRAINT fk_employer_id2 FOREIGN KEY (employer_id)
			 REFERENCES employer (employer_id) NOT NULL
)
GO

ALTER TABLE kind_of_activity_for_employer ADD CONSTRAINT pk_kind_of_activity_for_employer 
PRIMARY KEY (kind_of_activity_id, employer_id)